/* ***********************************************************
   Nueva tabla:   ambfer 
 ************************************************************* */
      
CREATE TABLE public.ambfer
(
  fecha timestamp without time zone NOT NULL,
  nombre character varying(100),
  inamovible character varying(1) NOT NULL,
  idambdb integer,
  fechainsert timestamp without time zone,
  fechaupdate timestamp without time zone,
  CONSTRAINT ambfer_pkey PRIMARY KEY (fecha)
)
WITH (
  OIDS=TRUE
);
ALTER TABLE public.ambfer OWNER TO abacouser;

-- Trigger: control_audit_ambfer on public.ambfer

-- DROP TRIGGER control_audit_ambfer ON public.ambfer;

CREATE TRIGGER control_audit_ambfer
  BEFORE INSERT OR UPDATE OR DELETE
  ON public.ambfer
  FOR EACH ROW
  EXECUTE PROCEDURE public.tg_control_audit_instancia();


-- =====================================
-- Borrar ambcfg.feriados SIN MIGRAR
-- =====================================

ALTER TABLE ambcfg DROP COLUMN feriados;

-- =====================================
   SELECT aaversion('397.00');
-- =====================================